Problem Note 36710: Selected variables are replaced by all variables after refreshing data in the SAS® Add-In for Microsoft Office
In Microsoft Excel, your selected variables might be replaced by all variables when you choose to refresh the data. This problem can occur if the variables appeared and were selected in the Modify Data Source dialog box as explained next:
- The variables were listed either in data set order or alphabetical order on the Available Variables tab.
- You selected just the first variable in the list, or you selected a contiguous group of variables starting with the first variable in the list.
- You opened these selected variables, in their original order, into the worksheet.
Under the circumstances above, when you refresh the data, all variables display instead of your selected variables.
This problem is planned to be fixed in a forthcoming maintenance release of the SAS Add-In for Microsoft Office.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-08-07 09:53:21 |
| Date Created: | 2009-08-04 13:40:17 |
